2013-06-26 - 7876 - Enhancement - Inventory Query #InventoryManagement

ENHANCEMENT

7876 - Inventory Query

Requirement Summary

---

Need to bucket inventory quantity into buckets in BEx.

Admin Info

---

Purpose	Need to bucket inventory quantity into buckets in BEx.
Requested By	Mark Harris
Spec Created By	Chandramouli K
Spec Created Date	06/26/2013
Spec QA by	Uday Kumar P
Objects	BEx Query VZDSOINE2_Q001_TEST
Document Status	Complete

References

---

Prior Tickets

None

Documents

None

Functional Requirement

---

For Stock and Standing Stock the buckets are determined as per following logic:

1. Calculate the average days supply as:
If Net available > 0 and (quantity sold in last month) = 0
then 999 days
Else Net Available / (Qty sold last month / Days in last period)

2. Sort the days supply in 0-30, 31-60, 61-90 and >90 days bucket based on above value in BEx.

Solution Summary

---

For designing the query to meet the NEC requirement, the following steps need to be followed:
1. Need to create BEx query.
2. Calculate Average days supply.
3. Need to define multiple formulas and calculated key figures.
4. Filter result into one of the buckets for 0-30, 31-60, 61-90 and >90 days.

Test Plan

SNo	Test Scenario	Expected Results
1	Check if the Average days supply value is correctly evaluated as per logic.	Average days supply value should be correctly calculated as applicable.
2	Check if the appropriate bucket is populated based on above value.	Average days supply should be placed in the appropriate bucket.

Solution Details

---

For designing the query to meet the NEC requirement, the following steps need to be followed:
1. Need to create BEx query based on the monthly inventory DSO ZDSOINE2.
2. Calculate Average days supply based on both conditions above.
3. Need to define multiple formulas and calculated key figures to determine the bucket values.
4. Based on the average days supply value, filter it into one of the buckets for 0-30, 31-60, 61-90 and >90 days.

Issues

---

None